Diagram Dialyses

Defincja diagramu Dialyses

Name

Dialyses

Code

Dialyses

Comment

Modul Dializ


Lista tabel diagramu

Name

Code

AntigenData

AntigenData

ChronicDisease

ChronicDisease

DialysedPatient

DialysedPatient

DialysedPatientType

DialysedPatientType

DialysedPatientTypeText

DialysedPatientTypeText

DialyseRelatedData

DialyseRelatedData

DialysisPost

DialysisPost

DialysisPostType

DialysisPostType

DialysisPostTypeText

DialysisPostTypeText

DialysisProlongLog

DialysisProlongLog

ExternalOrgUnit

ExternalOrgUnit

LOrgUnitDialysisPost

LOrgUnitDialysisPost

LPatientDayInterval

LPatientDayInterval

LPatientPerfServSchedule

LPatientPerfServSchedule

LPerfServiceSchedulePanel

LPerfServiceSchedulePanel

LPeritDialyseSchemeResItem

LPeritDialyseSchemeResItem

LResourceUnit

LResourceUnit

LServiceDialysisPost

LServiceDialysisPost

LStandingOrderPerfService

LStandingOrderPerfService

LSuspensionDialysedPatient

LSuspensionDialysedPatient

Panel

Panel

Patient

Patient

PerfDialysis

PerfDialysis

PerfResource

PerfResource

PerfService

PerfService

PerfServiceSchedule

PerfServiceSchedule

PerfServiceScheduleText

PerfServiceScheduleText

PeritDialyseScheme

PeritDialyseScheme

Person

Person

Personnel

Personnel

ResourceItem

ResourceItem

Service

Service

StandingOrder

StandingOrder

StandingOrderDrugFrequency

StandingOrderDrugFrequency

Suspension

Suspension

TimeConstraint

TimeConstraint

Transplantation

Transplantation

Unit

Unit


Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_8730

R_8730

Person

DialysedPatient

PersonID

 

 

R_8750

R_8750

Person

DialyseRelatedData

PersonID

 

 

R_8751

R_8751

Person

AntigenData

PersonID

 

 

R_8752

R_8752

Person

Transplantation

PersonID

 

 

R_8753

R_8753

Person

ChronicDisease

PersonID

 

 

R_8790

R_8790

Person

PeritDialyseScheme

PersonID

 

 

R_8791

R_8791

PeritDialyseScheme

LPeritDialyseSchemeResItem

PeritDialyseSchemeID

 

 

R_8792

R_8792

ResourceItem

LPeritDialyseSchemeResItem

ResourceID

 

 

R_9103

R_9103

ExternalOrgUnit

DialysedPatient

ExternalOrgUnitID

 

 

R_9104

R_9104

DialysedPatientType

DialysedPatientTypeText

DialysedPatientTypeID

 

 

R_9105

R_9105

DialysedPatientType

DialysedPatient

DialysedPatientTypeID

 

 

R_9108

R_9108

Patient

LSuspensionDialysedPatient

PersonID

 

 

R_9109

R_9109

Suspension

LSuspensionDialysedPatient

SuspensionID

 

 

R_9110

R_9110

Patient

TimeConstraint

PersonID

 

 

R_9112

R_9112

DialysisPostType

DialysisPostTypeText

DialysisPostTypeID

 

 

R_9113

R_9113

DialysisPostType

DialysisPost

DialysisPostTypeID

 

 

R_9114

R_9114

Service

LServiceDialysisPost

ServID

 

 

R_9115

R_9115

DialysisPost

LServiceDialysisPost

DialysisPostID

 

 

R_9117

R_9117

DialysisPost

LOrgUnitDialysisPost

DialysisPostID

 

 

R_9118

R_9118

DialysisPost

LPatientDayInterval

DialysisPostID

 

 

R_9150

R_9150

DialysedPatient

LPatientDayInterval

DialysedPatientID

 

 

R_9214

R_9214

PerfServiceSchedule

PerfServiceScheduleText

PerfServiceScheduleID

 

 

R_9215

R_9215

PerfServiceSchedule

LPerfServiceSchedulePanel

PerfServiceScheduleID

 

 

R_9216

R_9216

Panel

LPerfServiceSchedulePanel

PanelID

 

 

R_9217

R_9217

Person

LPatientPerfServSchedule

PersonID

 

 

R_9218

R_9218

PerfServiceSchedule

LPatientPerfServSchedule

PerfServiceScheduleID

 

 

R_9223

R_9223

Patient

StandingOrder

PersonID

 

 

R_9224

R_9224

Personnel

StandingOrder

OrderingPerson

 

 

R_9225

R_9225

StandingOrder

LStandingOrderPerfService

StandingOrderID

 

 

R_9226

R_9226

PerfService

LStandingOrderPerfService

PerfServiceID

 

 

R_9227

R_9227

Personnel

LStandingOrderPerfService

OrderingPerson

 

 

R_9240

R_9240

PerfService

PerfDialysis

PerfServiceID

 

 

R_9241

R_9241

StandingOrder

PerfDialysis

StandingOrderID

 

 

R_9267

R_9267

StandingOrder

StandingOrderDrugFrequency

StandingOrderID

 

 

R_9268

R_9268

Unit

StandingOrderDrugFrequency

UnitID

 

 

R_9269

R_9269

PerfResource

StandingOrderDrugFrequency

PerfResourceID

 

 

R_10242

R_10242

Unit

LResourceUnit

UnitID

 

 

R_10243

R_10243

Unit

LResourceUnit

Uni_UnitID

 

 

R_10244

R_10244

ResourceItem

LResourceUnit

ResourceID

 

 

R_10245

R_10245

DialysedPatient

DialysisProlongLog

DialysedPatientID

 

 

R_10246

R_10246

Person

DialysisProlongLog

PersonID

 

 

R_10247

R_10247

StandingOrderDrugFrequency

DialysisProlongLog

StandingOrderDrugFrequencyID

 

 

R_10248

R_10248

PerfResource

DialysisProlongLog

PerfResourceID